<%@ page contentType="text/html; charset=UTF-8" import="com.pub.database.QueryBean,java.util.*,com.pub.tools.PublicFunction,java.sql.*"%>
<%
  QueryBean qbnDAO = new QueryBean("MYSQL_GM",
                                 true, "BIG5", "BIG5");

  //Object[] keyArray=null;

  //Vector vtrData=new Vector();

  //vtrData.add(PublicFunction.getTimestempDate("2006/11/5 21:54:29"));
%>
<html>
<head>
<title>
testQueryBean
</title>
</head>
<body bgcolor="#ffffff">
<h1>
JBuilder Generated JSP
</h1>
<%
    out.println(qbnDAO.readSingleValueData("select count(*) from school_ext where emp_dept like '%林%' or emp_name  like '%林%' or emp_title like '%林%' or emp_ext like '%林%'"));
  //qbnDAO.executeSQL("insert into test values(?)",vtrData);

  //out.println("4<br/>");
  //out.println(PublicFunction.getSYSDATE(PublicFunction.getTimestempDate(qbnDAO.readSingleValueData("select test_date from test")).toString(),"yyyy/MM/dd"));
  //out.println(PublicFunction.getTimestempDate("2006/11/05 00:06"));
  /*try{
    Hashtable lhtTable = qbnDAO.hashtableSQL("select distinct wkf_frm1.fld_no,wkf_frm1.fld_kind,wkf_layout.wide_dec from wkf_frm1,wkf_layout,wkf_frm0 where wkf_frm1.prg_no='ams_flow_add' and wkf_frm0.prg_no=wkf_frm1.prg_no and wkf_frm0.frm_no=wkf_frm1.frm_no and wkf_frm0.dbf_no=wkf_layout.dbf_no and wkf_frm1.fld_no=wkf_layout.fld_no and wkf_frm1.fld_no is not null");

    out.println(lhtTable);
  }
  catch(Exception e){
    e.printStackTrace();
  }
  finally{
    try{qbnDAO.close();qbnDAO=null;}catch(Exception se){se.printStackTrace();}
  }*/
  /*for(int j=0;j<lhtData.size();j++){
    keyArray=((Hashtable)lhtData.get(String.valueOf(j))).keySet().toArray();
    out.print(j + ":");
    for(int i=0;i<=keyArray.length-1;i++){
      out.print(keyArray[i]);
      if(i<keyArray.length-1)out.print(",");
    }
  }*/

/*
        QueryBean qbnDAO = null;
        ResultSet rs=null;

        try{
            qbnDAO=new QueryBean("PIS1_SWD",true,"big5","big5");
            rs = qbnDAO.getConnection().getMetaData().getTables(null,null,null,new String[]{"TABLE"});

            while(rs.next()){
              out.println(rs.getString("TABLE_NAME"));
              out.println("<br/>");
            }
        }
        catch(Exception e){
            e.printStackTrace();
        }
        finally{
          if(rs!=null){
            try{
              rs.close();
              rs=null;
            }
            catch(Exception se){
              se.printStackTrace();
            }
          }
          if(qbnDAO!=null){
            try {
              qbnDAO.close();
              qbnDAO = null;
            } catch (Exception se) {
              se.printStackTrace();
            }
          }
        }*/
%>
</body>
</html>
